package com.tencent.backstage.dao.mapper;

import com.tencent.backstage.vo.SuggestPageVO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface SuggestMapper {
    @Select("select u.nick_name,s.id,s.openid,s.suggest,s.create_time from suggest s LEFT JOIN user_info u on s.openid = u.openid  order by s.create_time desc limit #{skip,jdbcType=INTEGER},#{limit,jdbcType=INTEGER} ")
    List<SuggestPageVO> getSuggest(@Param(value = "skip") Integer skip, @Param(value = "limit") Integer limit);
}
